Assessment for Spreadsheets
نویسندگان
چکیده
Spreadsheets are tools to model personal, business and scientific data and to support decision-making based on such models. Moreover, spreadsheets are used for communicating data, models, and decisions, which makes the interpretability of spreadsheet intents an important consideration in the design of spreadsheet interaction. In this paper we will focus on the problem of model assessment, i.e., the process of passing judgements on a situation based on modeled spreadsheet data, for instance, the development of profit over time represented in a controlling spreadsheet. We introduce a framework for specifying, documenting and personalizing assessments semi-formally and a set of plugins for the Semantic Alliance Architecture that can visualize assessments to assist the (spreadsheet) user in her decision-making.
منابع مشابه
Automating Spreadsheet Discovery & Risk Assessment
There have been many articles and mishaps published about the risks of uncontrolled spreadsheets in today’s business environment, including non-compliance, operational risk, errors, and fraud all leading to significant loss events. Spreadsheets fall into the realm of end user developed applications and are often absent the proper safeguards and controls an IT organization would enforce for ente...
متن کاملAn approach for the automated risk assessment of structural differences between spreadsheets (DiffXL)
This paper outlines an approach to manage and quantify the risks associated with changes made to spreadsheets. The methodology focuses on structural differences between spreadsheets and suggests a technique by which a risk analysis can be achieved in an automated environment. The paper offers an example that demonstrates how contiguous ranges of data can be mapped into a generic list of formula...
متن کاملRisk Assessment For Spreadsheet Developments: Choosing Which Models to Audit
Errors in spreadsheet applications and models are alarmingly common (some authorities, with justification cite spreadsheets containing errors as the norm rather than the exception). Faced with this body of evidence, the auditor can be faced with a huge task the temptation may be to launch code inspections for every spreadsheet in an organisation. This can be very expensive and time-consuming. T...
متن کاملWhat we understand is what we get: Assessment in Spreadsheets
In previous work we have studied how an explicit representation of background knowledge associated with a specific spreadsheet can be exploited to alleviate usability problems with spreadsheet-based applications. We have implemented this approach in the SACHS system to provide a semantic help system for spreadsheets applications. In this paper, we evaluate the (comprehension) coverage of SACHS ...
متن کاملWhat you understand is what you get: Assessment in Spreadsheets
Spreadsheets are heavily employed in administration, financial forecasting, education, and science because of their intuitive, flexible, and direct approach to computation. In previous work we have studied how an explicit representation of the background knowledge associated with the spreadsheet can be exploited to alleviate usability problems with spreadsheet-based applications. The SACHS syst...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2015